package com.py.ledger.mapper;

import java.util.List;
import com.py.ledger.domain.InventoryDetails;

/**
 * 库存预警Mapper接口
 * 
 * @author he
 * @date 2024-11-29
 */
public interface InventoryDetailsMapper 
{

    /**
     * 查询库存预警高于上限和低于下限
     * @return
     */
    List<InventoryDetails> selectLedgerDetail();

    /**
     * 查询库存预警
     * 
     * @param inventoryQueryId 库存预警主键
     * @return 库存预警
     */
    public InventoryDetails selectInventoryDetailsByInventoryQueryId(Long inventoryQueryId);

    /**
     * 查询库存预警列表
     * 
     * @param inventoryDetails 库存预警
     * @return 库存预警集合
     */
    public List<InventoryDetails> selectInventoryDetailsList(InventoryDetails inventoryDetails);

    /**
     * 新增库存预警
     * 
     * @param inventoryDetails 库存预警
     * @return 结果
     */
    public int insertInventoryDetails(InventoryDetails inventoryDetails);

    /**
     * 修改库存预警
     * 
     * @param inventoryDetails 库存预警
     * @return 结果
     */
    public int updateInventoryDetails(InventoryDetails inventoryDetails);

    /**
     * 删除库存预警
     * 
     * @param inventoryQueryId 库存预警主键
     * @return 结果
     */
    public int deleteInventoryDetailsByInventoryQueryId(Long inventoryQueryId);

    /**
     * 批量删除库存预警
     * 
     * @param inventoryQueryIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteInventoryDetailsByInventoryQueryIds(Long[] inventoryQueryIds);
}
